| SyServiceExceptionRequestQueue |
| Logical Entity Name | SyServiceExceptionRequestQueue |
| Default Table Name | SyServiceExceptionRequestQueue |
| Physical Only | NO |
| Definition | |
| Note |
| SyServiceExceptionRequestQueue Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SyServiceExceptionRequestQueueID |
int | NO | ||
SyServiceRequestID |
int | NO | ||
| Priority | int | NO | ||
| ExceptionCount | int | NO | ||
| SourceRecordCount | int | NO | ||
| QueuingStarted | datetime | NO | ||
| QueuingEnded | datetime | NO | ||
| DequeuingStarted | datetime | NO | ||
DequeueBySyServiceRequestID |
int | YES | ||
| ExceptionsDequeued | int | NO | ||
| SourceRecordsDequeued | int | NO | ||
| FailedInformation | nvarchar(max) | NO | ||
| QueueRequestStatus | int | NO | ||
| DequeuingEnded | datetime | NO | ||
| DequeuingAttempts | int | NO | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
| DequeueOriginated | varchar(8000) | NO | ||
| RequestSource | tinyint | NO |
| SyServiceExceptionRequestQueue Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_SyServiceExceptionRequestQueue_SyServiceExceptionRequestQueueID | PrimaryKey | SyServiceExceptionRequestQueueID |
| Uk_SyServiceExceptionRequestQueue_SyServiceRequestIdQueueRequestStatus | Index | SyServiceRequestID, QueueRequestStatus |
| SyServiceExceptionRequestQueue Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| SyServiceRequest | Non-Identifying | Zero or One to Zero or More | FK_SyServiceExceptionRequestQueueDequeueBySyServiceRequestID_SyServiceRequestSyServiceRequestID | DequeueBySyServiceRequestID | NO | YES | ||
| SyServiceRequest | Non-Identifying | One To Zero or More | FK_SyServiceExceptionRequestQueueSyServiceRequestID_SyServiceRequestSyServiceRequestID | SyServiceRequestID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_SyServiceExceptionRequestQueueUserID_SyStaffSyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| SyServiceExceptionQueue | Non-Identifying | One To Zero or More | FK_SyServiceExceptionQueueSyServiceExceptionRequestQueueID_SyServiceExceptionRequestQueueSyServiceExceptionRequestQueueID | NO | YES | |||
| SyServiceSourceRecordQueue | Non-Identifying | One To Zero or More | FK_SyServiceSourceRecordQueueSyServiceExceptionRequestQueueID_SyServiceExceptionRequestQueueSyServiceExceptionRequestQueueID | NO | YES |
| SyServiceExceptionRequestQueue Check Constraints |
| Check Constraint Name | CheckConstraint |